ApplyFixedValuesFilter(Boolean,IEnumerable<FixedDateGroup>) Method

Applies a Infragistics.Documents.Excel.Filtering.FixedValuesFilter to the column.

Syntax

C#

public FixedValuesFilter ApplyFixedValuesFilter( 
   bool includeBlanks,
   IEnumerable<FixedDateGroup> dateGroups
)

Parameters

includeBlanks

The value which indicates whether blank cells should be filtered in.

dateGroups

The collection of fixed date groups which should be filtered in.

Exceptions

Exception	Description
System.ArgumentNullException	dateGroups is null.
System.ArgumentNullException	A FixedDateGroup in the dateGroups collection is null.
System.ArgumentException	Multiple items in dateGroups are equal to each other.
System.InvalidOperationException	includeBlanks is False and dateGroups has no items. At least one value must be allowed.
System.InvalidOperationException	The WorksheetTable.IsFilterUIVisible value of the owning table is False. Filters cannot be applied when the header row or filter button is hidden.

Remarks

Note: If any text values are longer than 255 characters in length and the workbook is saved in one of the 2003 formats, the correct rows will be hidden in the saved file, but the filter may be missing from the column or reapplying the filter may hide some of the matching cells.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+